/***********************/
/* Database Deployment */
/***********************/


	exec sp_configure "clr enabled","1"
	RECONFIGURE WITH OVERRIDE

	Drop Procedure [dbo].[MPCreateModel]
	go

	Drop Assembly BIFramework
	go


	/* Deploy Assembly */
	Create Assembly BIFramework FROM 'E:\Solutions\Framework\MPCreateModel\MPCreateModel\bin\Debug\Essilor.Technical.BI.ModelManagement.dll' with permission_set = UNSAFE;
	go

	/* Link the Procedure */
	CREATE PROCEDURE [dbo].[MPCreateModel] @metadataConnectionString [nvarchar](max) 
	WITH EXECUTE AS CALLER 
	AS EXTERNAL NAME [BIFramework].[Essilor.Technical.BI.ModelManagement.StoredProcedures].[MPCreateModel]
	go
	
/************************/